{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-03-29T07:03:42.212403Z",
     "start_time": "2019-03-29T07:03:42.184599Z"
    }
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "pd.options.display.max_rows = 100\n",
    "pd.options.display.max_columns = 100\n",
    "\n",
    "import os, gc\n",
    "from glob import glob\n",
    "from tqdm import tqdm\n",
    "\n",
    "from sklearn.preprocessing import MinMaxScaler\n",
    "\n",
    "from matplotlib import pyplot as plt\n",
    "import seaborn as sns\n",
    "sns.set()\n",
    "\n",
    "import sys\n",
    "sys.path.append(f'/home/{os.environ.get(\"USER\")}/PythonLibrary')\n",
    "\n",
    "import EDA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-03-29T06:58:35.586362Z",
     "start_time": "2019-03-29T06:58:08.115981Z"
    }
   },
   "outputs": [],
   "source": [
    "tr = pd.read_csv('../input/train.csv.zip')\n",
    "te = pd.read_csv('../input/test.csv.zip')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-03-29T07:03:45.166391Z",
     "start_time": "2019-03-29T07:03:45.066030Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "119487    13.4994\n",
       "182308    13.5197\n",
       "27708     13.5316\n",
       "105309    13.5331\n",
       "180909    13.5529\n",
       "23924     13.5531\n",
       "62395     13.5533\n",
       "104686    13.5533\n",
       "26179     13.5533\n",
       "105389    13.5534\n",
       "139446    13.5534\n",
       "159512    13.5534\n",
       "69371     13.5534\n",
       "163876    13.5535\n",
       "37451     13.5535\n",
       "193253    13.5535\n",
       "182615    13.5535\n",
       "42871     13.5536\n",
       "131910    13.5536\n",
       "69898     13.5536\n",
       "45661     13.5536\n",
       "190405    13.5536\n",
       "15307     13.5536\n",
       "52171     13.5536\n",
       "38593     13.5536\n",
       "122041    13.5536\n",
       "156073    13.5537\n",
       "97460     13.5537\n",
       "180874    13.5537\n",
       "90394     13.5537\n",
       "141321    13.5537\n",
       "132238    13.5537\n",
       "142781    13.5537\n",
       "153975    13.5537\n",
       "7930      13.5537\n",
       "92039     13.5537\n",
       "77846     13.5538\n",
       "183611    13.5538\n",
       "105948    13.5538\n",
       "139392    13.5538\n",
       "61913     13.5538\n",
       "158859    13.5538\n",
       "147332    13.5538\n",
       "69663     13.5538\n",
       "67201     13.5538\n",
       "46547     13.5538\n",
       "41217     13.5538\n",
       "36406     13.5539\n",
       "11063     13.5539\n",
       "151200    13.5539\n",
       "           ...   \n",
       "79581     14.4717\n",
       "43315     14.4718\n",
       "185237    14.4736\n",
       "102411    14.4741\n",
       "85828     14.4750\n",
       "82663     14.4767\n",
       "97970     14.4769\n",
       "25797     14.4773\n",
       "97119     14.4774\n",
       "35366     14.4776\n",
       "91211     14.4801\n",
       "185317    14.4801\n",
       "63835     14.4817\n",
       "190203    14.4820\n",
       "79986     14.4850\n",
       "194035    14.4859\n",
       "157877    14.4882\n",
       "191140    14.4889\n",
       "190351    14.4893\n",
       "49080     14.4906\n",
       "190632    14.4908\n",
       "146675    14.4929\n",
       "102796    14.4946\n",
       "157903    14.4947\n",
       "27520     14.4955\n",
       "15328     14.4965\n",
       "41188     14.4967\n",
       "63643     14.4994\n",
       "155394    14.5038\n",
       "143033    14.5088\n",
       "77247     14.5107\n",
       "123918    14.5143\n",
       "139640    14.5147\n",
       "121070    14.5177\n",
       "165276    14.5189\n",
       "29319     14.5217\n",
       "105296    14.5224\n",
       "162815    14.5259\n",
       "100757    14.5265\n",
       "7840      14.5274\n",
       "81797     14.5313\n",
       "23222     14.5341\n",
       "91856     14.5559\n",
       "14859     14.5564\n",
       "186942    14.5663\n",
       "173483    14.5668\n",
       "45555     14.5707\n",
       "5564      14.5718\n",
       "107647    14.5883\n",
       "197044    14.6334\n",
       "Name: var_12, Length: 20098, dtype: float64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tr[tr.target==1]['var_12'].sort_values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-03-29T07:03:51.025963Z",
     "start_time": "2019-03-29T07:03:50.592681Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "123780    13.4346\n",
       "11380     13.4884\n",
       "194133    13.4921\n",
       "29748     13.4944\n",
       "82874     13.4952\n",
       "82966     13.4952\n",
       "91022     13.5057\n",
       "83765     13.5130\n",
       "88502     13.5174\n",
       "131827    13.5186\n",
       "184107    13.5188\n",
       "87697     13.5197\n",
       "127855    13.5241\n",
       "126797    13.5241\n",
       "147644    13.5264\n",
       "108007    13.5265\n",
       "37661     13.5295\n",
       "185288    13.5333\n",
       "124457    13.5333\n",
       "152713    13.5343\n",
       "114005    13.5394\n",
       "113542    13.5404\n",
       "134326    13.5411\n",
       "169397    13.5417\n",
       "20725     13.5428\n",
       "143003    13.5428\n",
       "55585     13.5429\n",
       "158851    13.5449\n",
       "159654    13.5492\n",
       "50291     13.5494\n",
       "132162    13.5500\n",
       "181239    13.5500\n",
       "87324     13.5501\n",
       "135272    13.5514\n",
       "148382    13.5530\n",
       "188529    13.5531\n",
       "7916      13.5531\n",
       "97826     13.5531\n",
       "41105     13.5531\n",
       "118147    13.5531\n",
       "194273    13.5532\n",
       "50729     13.5532\n",
       "40414     13.5533\n",
       "129397    13.5533\n",
       "32649     13.5533\n",
       "106968    13.5533\n",
       "172223    13.5533\n",
       "66182     13.5534\n",
       "86448     13.5534\n",
       "188857    13.5534\n",
       "           ...   \n",
       "138929    14.5575\n",
       "170799    14.5575\n",
       "157933    14.5575\n",
       "23536     14.5576\n",
       "106026    14.5582\n",
       "178949    14.5587\n",
       "98066     14.5588\n",
       "84192     14.5596\n",
       "67475     14.5598\n",
       "80130     14.5604\n",
       "86051     14.5620\n",
       "18995     14.5627\n",
       "73387     14.5639\n",
       "159269    14.5645\n",
       "85607     14.5668\n",
       "31398     14.5677\n",
       "151391    14.5688\n",
       "49447     14.5697\n",
       "190907    14.5702\n",
       "105578    14.5703\n",
       "87596     14.5703\n",
       "171140    14.5707\n",
       "153749    14.5718\n",
       "38570     14.5733\n",
       "160850    14.5755\n",
       "192069    14.5757\n",
       "79018     14.5775\n",
       "135573    14.5775\n",
       "159084    14.5778\n",
       "47307     14.5792\n",
       "164866    14.5806\n",
       "138555    14.5888\n",
       "21942     14.5891\n",
       "58092     14.5904\n",
       "112488    14.5925\n",
       "4480      14.5954\n",
       "132444    14.5960\n",
       "147551    14.5965\n",
       "89843     14.5993\n",
       "99049     14.5997\n",
       "149637    14.6144\n",
       "57953     14.6241\n",
       "184880    14.6242\n",
       "189702    14.6243\n",
       "23626     14.6295\n",
       "46860     14.6349\n",
       "134577    14.6364\n",
       "48758     14.6402\n",
       "89878     14.6456\n",
       "119966    14.6545\n",
       "Name: var_12, Length: 179902, dtype: float64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tr[tr.target==0]['var_12'].sort_values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-03-29T07:11:12.955989Z",
     "start_time": "2019-03-29T07:11:12.823899Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>var_81</th>\n",
       "      <th>var_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13.8372</td>\n",
       "      <td>-6.7863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18.1782</td>\n",
       "      <td>-4.1473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>15.7811</td>\n",
       "      <td>-2.7457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10.5404</td>\n",
       "      <td>-2.1518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13.3317</td>\n",
       "      <td>-1.4834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>15.3766</td>\n",
       "      <td>-2.3182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>12.3111</td>\n",
       "      <td>-0.0832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>13.3314</td>\n",
       "      <td>-7.9881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>14.8569</td>\n",
       "      <td>2.4426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>16.6244</td>\n",
       "      <td>1.9743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>15.1476</td>\n",
       "      <td>-0.5447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>14.4600</td>\n",
       "      <td>-7.9750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>19.8428</td>\n",
       "      <td>-4.6154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>12.1677</td>\n",
       "      <td>1.5934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14.9304</td>\n",
       "      <td>5.0514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15.3367</td>\n",
       "      <td>2.6562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>9.6918</td>\n",
       "      <td>0.2689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17.2389</td>\n",
       "      <td>-1.8128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>14.7277</td>\n",
       "      <td>1.2646</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>17.5206</td>\n",
       "      <td>-0.7863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>15.0392</td>\n",
       "      <td>-2.0221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>19.0543</td>\n",
       "      <td>1.4806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>11.9410</td>\n",
       "      <td>0.1925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>14.1861</td>\n",
       "      <td>-9.3439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>17.2719</td>\n",
       "      <td>-3.7285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>14.7120</td>\n",
       "      <td>-5.6854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>13.9720</td>\n",
       "      <td>-4.4950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>14.2670</td>\n",
       "      <td>-9.9800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>13.3554</td>\n",
       "      <td>4.5262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>15.2648</td>\n",
       "      <td>-2.6064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>15.6072</td>\n",
       "      <td>2.6285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>10.7966</td>\n",
       "      <td>2.4613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>15.6986</td>\n",
       "      <td>-4.6105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>13.9003</td>\n",
       "      <td>0.6422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>20.3593</td>\n",
       "      <td>0.6652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>18.3401</td>\n",
       "      <td>-6.0942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>13.1140</td>\n",
       "      <td>-2.4150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>11.7054</td>\n",
       "      <td>-0.9335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>14.8360</td>\n",
       "      <td>2.1665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>15.2773</td>\n",
       "      <td>-4.0868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>16.4323</td>\n",
       "      <td>1.3359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>13.6670</td>\n",
       "      <td>2.4231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>13.3860</td>\n",
       "      <td>-6.9861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>15.1054</td>\n",
       "      <td>-2.2579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>14.5497</td>\n",
       "      <td>-7.3003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>14.4274</td>\n",
       "      <td>-4.7731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>13.7620</td>\n",
       "      <td>4.9384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>9.2023</td>\n",
       "      <td>6.8285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>14.6432</td>\n",
       "      <td>3.4296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>16.7957</td>\n",
       "      <td>1.4462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199950</th>\n",
       "      <td>16.1131</td>\n",
       "      <td>1.3131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199951</th>\n",
       "      <td>14.7696</td>\n",
       "      <td>1.7688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199952</th>\n",
       "      <td>17.8697</td>\n",
       "      <td>-5.6768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199953</th>\n",
       "      <td>15.6887</td>\n",
       "      <td>-8.7172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199954</th>\n",
       "      <td>12.0110</td>\n",
       "      <td>1.0789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199955</th>\n",
       "      <td>15.1019</td>\n",
       "      <td>-0.5086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199956</th>\n",
       "      <td>12.7639</td>\n",
       "      <td>2.4673</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199957</th>\n",
       "      <td>12.2116</td>\n",
       "      <td>-3.5890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199958</th>\n",
       "      <td>18.1790</td>\n",
       "      <td>-8.9352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199959</th>\n",
       "      <td>17.0109</td>\n",
       "      <td>-6.0808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199960</th>\n",
       "      <td>16.8685</td>\n",
       "      <td>-8.6373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199961</th>\n",
       "      <td>15.3056</td>\n",
       "      <td>-6.7574</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199962</th>\n",
       "      <td>15.4649</td>\n",
       "      <td>-6.0287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199963</th>\n",
       "      <td>12.1895</td>\n",
       "      <td>-3.6821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199964</th>\n",
       "      <td>9.0404</td>\n",
       "      <td>-6.2851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199965</th>\n",
       "      <td>12.4380</td>\n",
       "      <td>2.6666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199966</th>\n",
       "      <td>13.0774</td>\n",
       "      <td>2.5526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199967</th>\n",
       "      <td>14.4882</td>\n",
       "      <td>4.4399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199968</th>\n",
       "      <td>14.6600</td>\n",
       "      <td>2.9068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199969</th>\n",
       "      <td>9.7153</td>\n",
       "      <td>-3.7369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199970</th>\n",
       "      <td>15.9507</td>\n",
       "      <td>-2.5687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199971</th>\n",
       "      <td>14.8752</td>\n",
       "      <td>-3.9178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199972</th>\n",
       "      <td>18.6671</td>\n",
       "      <td>-2.5972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199973</th>\n",
       "      <td>19.8027</td>\n",
       "      <td>-0.4604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199974</th>\n",
       "      <td>18.4264</td>\n",
       "      <td>-5.7847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199975</th>\n",
       "      <td>17.6878</td>\n",
       "      <td>1.0548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199976</th>\n",
       "      <td>18.5354</td>\n",
       "      <td>-2.8485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199977</th>\n",
       "      <td>14.2220</td>\n",
       "      <td>-0.8093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199978</th>\n",
       "      <td>13.1522</td>\n",
       "      <td>-0.8787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199979</th>\n",
       "      <td>12.1677</td>\n",
       "      <td>-2.9344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199980</th>\n",
       "      <td>10.9518</td>\n",
       "      <td>6.2271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199981</th>\n",
       "      <td>15.3759</td>\n",
       "      <td>0.6386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199982</th>\n",
       "      <td>15.1338</td>\n",
       "      <td>-2.3596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199983</th>\n",
       "      <td>14.7983</td>\n",
       "      <td>2.8260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199984</th>\n",
       "      <td>18.2239</td>\n",
       "      <td>0.3745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199985</th>\n",
       "      <td>16.8027</td>\n",
       "      <td>-3.6379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199986</th>\n",
       "      <td>16.0686</td>\n",
       "      <td>-8.7800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199987</th>\n",
       "      <td>21.5484</td>\n",
       "      <td>-1.9184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199988</th>\n",
       "      <td>17.1202</td>\n",
       "      <td>-8.3545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199989</th>\n",
       "      <td>16.0028</td>\n",
       "      <td>-4.5356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199990</th>\n",
       "      <td>11.8592</td>\n",
       "      <td>1.8568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199991</th>\n",
       "      <td>18.0211</td>\n",
       "      <td>2.5523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199992</th>\n",
       "      <td>11.7073</td>\n",
       "      <td>2.6918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199993</th>\n",
       "      <td>15.6820</td>\n",
       "      <td>-5.8006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199994</th>\n",
       "      <td>10.2997</td>\n",
       "      <td>-5.8821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199995</th>\n",
       "      <td>16.3870</td>\n",
       "      <td>-0.4956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199996</th>\n",
       "      <td>17.9954</td>\n",
       "      <td>-2.4484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199997</th>\n",
       "      <td>16.9399</td>\n",
       "      <td>-5.0518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199998</th>\n",
       "      <td>21.4391</td>\n",
       "      <td>-8.6098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199999</th>\n",
       "      <td>14.7593</td>\n",
       "      <td>-5.7105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         var_81   var_1\n",
       "0       13.8372 -6.7863\n",
       "1       18.1782 -4.1473\n",
       "2       15.7811 -2.7457\n",
       "3       10.5404 -2.1518\n",
       "4       13.3317 -1.4834\n",
       "5       15.3766 -2.3182\n",
       "6       12.3111 -0.0832\n",
       "7       13.3314 -7.9881\n",
       "8       14.8569  2.4426\n",
       "9       16.6244  1.9743\n",
       "10      15.1476 -0.5447\n",
       "11      14.4600 -7.9750\n",
       "12      19.8428 -4.6154\n",
       "13      12.1677  1.5934\n",
       "14      14.9304  5.0514\n",
       "15      15.3367  2.6562\n",
       "16       9.6918  0.2689\n",
       "17      17.2389 -1.8128\n",
       "18      14.7277  1.2646\n",
       "19      17.5206 -0.7863\n",
       "20      15.0392 -2.0221\n",
       "21      19.0543  1.4806\n",
       "22      11.9410  0.1925\n",
       "23      14.1861 -9.3439\n",
       "24      17.2719 -3.7285\n",
       "25      14.7120 -5.6854\n",
       "26      13.9720 -4.4950\n",
       "27      14.2670 -9.9800\n",
       "28      13.3554  4.5262\n",
       "29      15.2648 -2.6064\n",
       "30      15.6072  2.6285\n",
       "31      10.7966  2.4613\n",
       "32      15.6986 -4.6105\n",
       "33      13.9003  0.6422\n",
       "34      20.3593  0.6652\n",
       "35      18.3401 -6.0942\n",
       "36      13.1140 -2.4150\n",
       "37      11.7054 -0.9335\n",
       "38      14.8360  2.1665\n",
       "39      15.2773 -4.0868\n",
       "40      16.4323  1.3359\n",
       "41      13.6670  2.4231\n",
       "42      13.3860 -6.9861\n",
       "43      15.1054 -2.2579\n",
       "44      14.5497 -7.3003\n",
       "45      14.4274 -4.7731\n",
       "46      13.7620  4.9384\n",
       "47       9.2023  6.8285\n",
       "48      14.6432  3.4296\n",
       "49      16.7957  1.4462\n",
       "...         ...     ...\n",
       "199950  16.1131  1.3131\n",
       "199951  14.7696  1.7688\n",
       "199952  17.8697 -5.6768\n",
       "199953  15.6887 -8.7172\n",
       "199954  12.0110  1.0789\n",
       "199955  15.1019 -0.5086\n",
       "199956  12.7639  2.4673\n",
       "199957  12.2116 -3.5890\n",
       "199958  18.1790 -8.9352\n",
       "199959  17.0109 -6.0808\n",
       "199960  16.8685 -8.6373\n",
       "199961  15.3056 -6.7574\n",
       "199962  15.4649 -6.0287\n",
       "199963  12.1895 -3.6821\n",
       "199964   9.0404 -6.2851\n",
       "199965  12.4380  2.6666\n",
       "199966  13.0774  2.5526\n",
       "199967  14.4882  4.4399\n",
       "199968  14.6600  2.9068\n",
       "199969   9.7153 -3.7369\n",
       "199970  15.9507 -2.5687\n",
       "199971  14.8752 -3.9178\n",
       "199972  18.6671 -2.5972\n",
       "199973  19.8027 -0.4604\n",
       "199974  18.4264 -5.7847\n",
       "199975  17.6878  1.0548\n",
       "199976  18.5354 -2.8485\n",
       "199977  14.2220 -0.8093\n",
       "199978  13.1522 -0.8787\n",
       "199979  12.1677 -2.9344\n",
       "199980  10.9518  6.2271\n",
       "199981  15.3759  0.6386\n",
       "199982  15.1338 -2.3596\n",
       "199983  14.7983  2.8260\n",
       "199984  18.2239  0.3745\n",
       "199985  16.8027 -3.6379\n",
       "199986  16.0686 -8.7800\n",
       "199987  21.5484 -1.9184\n",
       "199988  17.1202 -8.3545\n",
       "199989  16.0028 -4.5356\n",
       "199990  11.8592  1.8568\n",
       "199991  18.0211  2.5523\n",
       "199992  11.7073  2.6918\n",
       "199993  15.6820 -5.8006\n",
       "199994  10.2997 -5.8821\n",
       "199995  16.3870 -0.4956\n",
       "199996  17.9954 -2.4484\n",
       "199997  16.9399 -5.0518\n",
       "199998  21.4391 -8.6098\n",
       "199999  14.7593 -5.7105\n",
       "\n",
       "[200000 rows x 2 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tr[['var_81', 'var_1']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
